 create external table jms_dim.dim_ep_standard_post_base (
   id bigint comment 'id',
   production_processes_id string comment '工序id',
   post string comment '岗位',
   post_name string comment '岗位名称',
   post_code string comment '岗位编码',
   post_explain string comment '岗位说明',
   facility_value string comment '难易程度',
   scan_type_id string comment '扫描类型id',
   value_logistic_explain string comment '取值逻辑说明',
   remark string comment '备注',
   is_enable smallint comment '启用状态（1-是 0-否）',
   create_by bigint comment '创建人id',
   create_by_name string comment '创建人姓名',
   create_time timestamp comment '创建时间',
   modify_by bigint comment '修改人id',
   modify_by_name string comment '创建人姓名',
   modify_time TIMESTAMP comment '修改时间',
   by_piece smallint comment '是否计件（1-是 0-否）'
)
comment  '标准岗位'
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/dw/hive/jms_dim.db/external/dim_ep_standard_post_base';